#!/usr/bin/env python
#-*- coding:utf-8 -*-

# file:models.py
# author:张世航
# datetime:2024/12/22 16:01
# software: PyCharm
"""
this is function  description 
"""




from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class Student(db.Model):
    __tablename__ = 'student'
    Sno = db.Column(db.String(20), primary_key=True)
    Sname = db.Column(db.String(20), nullable=False)
    Ssex = db.Column(db.String(20), nullable=False)
    Sage = db.Column(db.Integer, nullable=False)
    Dno = db.Column(db.String(20), nullable=False)
    Sclass = db.Column(db.String(20), nullable=True)
    address = db.Column(db.String(255), nullable=True)
